How can I correctly implement a nested CASE statement for the svcState column in my SQL query